﻿if exists (select * from dbo.sysobjects where name = 'sp_Parts_Update')	drop procedure [dbo].[sp_Parts_Update]Go CREATE PROCEDURE dbo.sp_Parts_Update	@paID		int,	@dpId		int,	@Name		nvarchar(300),	@Ord		intAS	UPDATE [Parts] SET [dpId] = @dpId, [Name] = @Name, [Ord] = @Ord	 WHERE paID = @paIDGo 